TPC-D: Benchmarking for Decision Support
نویسنده
چکیده
In the 1990 world that the TPC-D development effort was born into, decision support was a minor league game. The term “data warehouse” had not yet been coined, and many of the parallel technologies taking aim at decision support were still on the drawing board. Global competition had not yet forced corporations into serious self-examination, nor had it taught them to respect and cherish their data. So the knowledge base, the experience level, and the interest in decision support, both in and out of the TPC Council, was in its infancy.
منابع مشابه
Reducing TPC-H Benchmarking Time
Benchmarking a system can be a time consuming operation. Therefore, many researchers have developed kernels and microbenchmarks. Nevertheless, these programs are not able to capture the details of a full application. One such example are the complex database applications. In this work we present a methodology based on a statistical method, Principal Component Analysis, in order to reduce the ex...
متن کاملBenchmarking Using Basic DBMS Operations
The TPC-H benchmark proved to be successful in the decision support area. Many commercial database vendors and their related hardware vendors used these benchmarks to show the superiority and competitive edge of their products. However, over time, the TPC-H became less representative of industry trends as vendors keep tuning their database to this benchmark-specific workload. In this paper, we ...
متن کاملBenchmarking with TPC-H on Off-the-Shelf Hardware - An Experiments Report
Most medium-sized enterprises run their databases on inexpensive off-the-shelf hardware; still, answers to quite complex queries, like ad-hoc Decision Support System (DSS) ones, are required within a reasonable time window. Therefore, it becomes increasingly important that the chosen database system and its tuning be optimal for the specific database size and design. Such optimization could occ...
متن کاملKeeping the TPC Relevant!
The Transaction Processing Performance Council (TPC) is a nonprofit organization founded in 1988 to define transaction processing and database benchmarks. Since then, the TPC has played a crucial role in providing the industry with relevant standards for total system performance, price-performance, and energy-efficiency comparisons. TPC benchmarks are widely used by database researchers and aca...
متن کاملBenchmarking PostgreSQL for data warehousing
Often in a competitive market, corporations need tools to increase the accuracy and efficiency of the decisions. Facing this, several companies that have no resources to buy the commercial systems available because of the high costs, have no chance to buy a Decision Support Systems (DSS) platform. This paper is dedicated to a benchmark of PostgreSQL DBMS for data warehouse as part of a low cost...
متن کامل